CREATING LINE AND CLUSTRED CHART 1 13

Create line and clustered column chart for GPM% and YOY% by month 

STEP 1 – Copy and paste the previous visual. Click on it and Go to visualization, Click on Line and Clustered Column Chart

STEP 2- Remove all the field, Drag and drop Gross Profit Margin % in the Column values, YOY % in line values and Month in the share axis from the date hierarchy.

STEP 3 - Go to formatting and change the title to GPM% by Month 

Follow the GIF below to apply the above steps 

STEP 4- Go to X Axis. Font color = black, text size 9, font family = Arial black and turn the title off

STEP 5- Go to y Axis. Font color = black, text size 9, font family = Arial black and turn the title off, turn on show secondary line and make the same font with the first line

Follow the GIF below to apply the above steps


STEP 6 – Go to Legend and make the color= black, text size=12, font family= Din

STEP 7- Turn on data label, change the color = black, decimal place =1, show background off, turn on customize serious and change it to YOY%. Color = #8d6fd1, decimal place=1, text size= 9, font family = Arial black, Show background off

Follow the GIF below to apply the above steps

STEP 8– Click Data on data color YOY% = color #2e1039, for the default =color #71afe2

STEP 9- Click on shape and turn on the shade area

STEP 10 – Go to y Axis and change the secondary line to color=# #8d6fd1

Follow the GIF below to apply the above steps


How to create line and clustered column chart